CREATE TABLE [dbo].[EventSetupRegistrant]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RegistrantPageMessage] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstNameEnabled] [bit] NOT NULL,
[FirstNameRequired] [bit] NOT NULL,
[MiddleInitial] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleInitialEnabled] [bit] NOT NULL,
[MiddleInitialRequired] [bit] NOT NULL,
[LastName] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastNameEnabled] [bit] NOT NULL,
[LastNameRequired] [bit] NOT NULL,
[Address] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AddressEnabled] [bit] NOT NULL,
[AddressRequired] [bit] NOT NULL,
[City] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CityEnabled] [bit] NOT NULL,
[CityRequired] [bit] NOT NULL,
[StateProvince] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StateEnabled] [bit] NOT NULL,
[StateRequired] [bit] NOT NULL,
[PostalCode] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PostalCodeEnabled] [bit] NOT NULL,
[PostalCodeRequired] [bit] NOT NULL,
[Phone] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PhoneEnabled] [bit] NOT NULL,
[PhoneRequired] [bit] NOT NULL,
[Email] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EmailEnabled] [bit] NOT NULL,
[EmailRequired] [bit] NOT NULL,
[Country] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CountryEnabled] [bit] NULL,
[CountryRequired] [bit] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupRegistrant] ADD CONSTRAINT [PK_EventSetupRegistrant] PRIMARY KEY CLUSTERED ([EventCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupRegistrant] ADD CONSTRAINT [FK_EventSetupRegistrant_EventSetupGeneral] FOREIGN KEY ([EventCode]) REFERENCES [dbo].[EventSetupGeneral] ([EventCode])
GO